Create Staging Table in Staging Database and Populate the Staging Tables - Continued 10
·
Drag
and Drop the ForEachLoop Container – double click and add the file path in the
collections tab and add the JsonFilePath variable in the Variable mapping tab
·
Drag
and drop the sequence container.
·
Drag
Execute SQL Task inside the sequence container - Double Click and Add
Connection manager and Write Sql Query
·
Drag
and drop the Data Flow Task inside the sequence container - Double Click
§ Drag and drop the Flat File Source and add the
Flat File connection manager
§ Drag and drop the Data Conversion transformation -
to convert the apprpriate Data Types
§ Drag and drop the OLEDB Destination - add the destination connection manager and select the staging table to load the data
Execute the Package in SSIS to load the Data into the Staging tables
The Staging tables are populated with the data from the Source Files